DB Maintenance lets you permanently delete entries from .NET tables that were previously purged from Client/Server tables.
Caution! Be sure to follow the order here: complete your Client/Server membership purge before proceeding to those in DB Maintenance, and always purge user records before purging contact records.
To purge membership records across iMIS
1. Purge member records in Name-related tables.
1. In iMIS Desktop, select Utilities > Reports and Queries from the menu.
2. Select Purge, Membership Purge for MS SQL and select Run.
The Membership Purge is for the Name table and those tables related to it.
2. Purge user records in .NET tables.
1. In DB Maintenance, select the NetContacts tab.
2. Click Purge Unused Users.
3. Check the estimate for the number of records eligible for purging reported by the Purge Confirmation window, and troubleshoot if it seems wrong.
4. Click Continue with Purge. The purge can take minutes or hours, depending on the number of records involved. Entries from the following .NET tables are deleted:
■ aspnet_Profile
■ aspnet_Membership
■ aspnet_Users
■ Users
■ UserMain
■ UserRole
■ UserToken
5. When the purge is done, check the history log that displays for the success and number of records that were purged.
3. Purge contact records in .NET tables.
1. Click Purge Unused Contacts.
2. Check the estimate for the number of records eligible for purging reported by the Purge Confirmation window, and troubleshoot if it seems wrong.
3. Click Continue with Purge. The purge can take minutes or hours, depending on the number of records involved. Entries from the following .NET tables are deleted:
■ GroupMember
■ GroupMemberDetail
■ RFMMain
■ Individual
■ Institute
■ ContactBiography
■ ContactCommunicationReasonPreferences
■ ContactLog
■ ContactPicture
■ ContactSalutation
■ ContactMain
■ PrimaryInstituteContactKey is set to null for all related institute records
4. When the purge is done, check the history log that displays for the success and number of records that were purged.